Thanks everyone for such quick and thorough answers. Rob Simpson said I'd
probably
get "a million replies" and he wasn't far off.

Here was the original question:

> -----Original Message-----
> From: ARCVIEW-L [mailto:ARCVIEW-L@ESRI.COM]On Behalf Of Hamilton,
> Jeffrey
> Sent: Wednesday, October 24, 2001 2:47 PM
> To: ARCVIEW-L@ESRI.COM
> Subject: [ARCVIEW-L] Query for Odd Numbers
>
>
> I have a numeric field that contains data with from 1 to 4 characters. How
> can I search for just the odd-numbered data? I want to find 741,
> 1113, 697,
> etc., but not 698, 742, etc.
>
> Thanks for your help.
>
> Jeff

And here are the two best answers.
>Jeff,
>Try the following statement in the field calculator (where "AnyNumber" is
the name of the field containing the odd and even numbers:
>([AnyNumber] Mod 2 <> 0)
>The Mod function returns the remainder of a division operation...so any odd
number divided by 2 will return a remainder. Likwise, if you wanted to
search for all even >numbers, change the argument to "=" instead of "<>".
Attached is a *.jpg image of the field calculator and selection results in
AV3.2.
>Respectfully,
>Chris
>Chris Mack - Coastal Engineer
>
>Jeff,


>The query you need looks something like:
>
>([Field_name].mod(2) = 1)
>
>.mod is the modula: the remainder of division by the argument (2)
>
>Farley Klotz
>GIS Programmer / Analyst